﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DataSetFacturacion" targetNamespace="http://tempuri.org/DataSetFacturacion.xsd" xmlns:mstns="http://tempuri.org/DataSetFacturacion.xsd" xmlns="http://tempuri.org/DataSetFacturacion.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="FacturacionConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="FacturacionConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.CASFacturacion.Properties.Settings.GlobalReference.Default.FacturacionConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProductoTableAdapter" GeneratorDataComponentClassName="ProductoTableAdapter" Name="Producto" UserDataComponentName="ProductoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FacturacionConnectionString (Settings)" DbObjectName="Facturacion.dbo.Producto" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Producto] WHERE (([IDProducto] = @Original_IDProducto) AND ([Descripcion] = @Original_Descripcion) AND ([Precio] = @Original_Precio) AND ([Stock] = @Original_Stock) AND ([IDIVA] = @Original_IDIVA) AND ([IDDepartamento] = @Original_IDDepartamento))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDProducto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDProducto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Precio" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Precio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Stock" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Stock" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDIVA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDIVA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDDepartamento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDDepartamento" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Producto] ([Descripcion], [Precio], [Stock], [Notas], [IDIVA], [IDDepartamento]) VALUES (@Descripcion, @Precio, @Stock, @Notas, @IDIVA, @IDDepartamento);
SELECT IDProducto, Descripcion, Precio, Stock, Notas, IDIVA, IDDepartamento FROM Producto WHERE (IDProducto = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Precio" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Precio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Stock" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Stock" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Notas" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="Notas" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDIVA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDIVA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDDepartamento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDDepartamento" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDProducto, Descripcion, Precio, Stock, Notas, IDIVA, IDDepartamento FROM dbo.Producto</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Producto] SET [Descripcion] = @Descripcion, [Precio] = @Precio, [Stock] = @Stock, [Notas] = @Notas, [IDIVA] = @IDIVA, [IDDepartamento] = @IDDepartamento WHERE (([IDProducto] = @Original_IDProducto) AND ([Descripcion] = @Original_Descripcion) AND ([Precio] = @Original_Precio) AND ([Stock] = @Original_Stock) AND ([IDIVA] = @Original_IDIVA) AND ([IDDepartamento] = @Original_IDDepartamento));
SELECT IDProducto, Descripcion, Precio, Stock, Notas, IDIVA, IDDepartamento FROM Producto WHERE (IDProducto = @IDProducto)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Precio" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Precio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Stock" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Stock" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Notas" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="Notas" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDIVA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDIVA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDDepartamento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDDepartamento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDProducto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDProducto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Precio" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Precio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Stock" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Stock" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDIVA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDIVA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDDepartamento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDDepartamento" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDProducto" ColumnName="IDProducto" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDProducto" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDProducto" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDProducto" DataSetColumn="IDProducto" />
              <Mapping SourceColumn="Descripcion" DataSetColumn="Descripcion" />
              <Mapping SourceColumn="Precio" DataSetColumn="Precio" />
              <Mapping SourceColumn="Stock" DataSetColumn="Stock" />
              <Mapping SourceColumn="Notas" DataSetColumn="Notas" />
              <Mapping SourceColumn="IDIVA" DataSetColumn="IDIVA" />
              <Mapping SourceColumn="IDDepartamento" DataSetColumn="IDDepartamento" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="FacturacionConnectionString (Settings)" DbObjectName="Facturacion.dbo.Producto" DbObjectType="Table" GenerateShortCommands="true" GeneratorSourceName="getDescripcionDeProductoConId" Modifier="Public" Name="getDescripcionDeProductoConId" QueryType="Scalar" ScalarCallRetval="System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="getDescripcionDeProductoConId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Descripcion FROM Producto WHERE (IDProducto = @IDProducto)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="IDProducto" ColumnName="IDProducto" DataSourceName="Facturacion.dbo.Producto" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDProducto" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDProducto" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="FacturacionConnectionString (Settings)" DbObjectName="Facturacion.dbo.Producto" DbObjectType="Table" GenerateShortCommands="true" GeneratorSourceName="getPrecioDelProductoConId" Modifier="Public" Name="getPrecioDelProductoConId" QueryType="Scalar" ScalarCallRetval="System.Decimal, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="getPrecioDelProductoConId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Precio FROM Producto WHERE (IDProducto = @IDProducto)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="IDProducto" ColumnName="IDProducto" DataSourceName="Facturacion.dbo.Producto" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDProducto" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDProducto" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="FacturacionConnectionString (Settings)" DbObjectName="Facturacion.dbo.Producto" DbObjectType="Table" GenerateShortCommands="true" GeneratorSourceName="getStockDelProductoConId" Modifier="Public" Name="getStockDelProductoConId" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="getStockDelProductoConId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Stock
FROM            Producto
WHERE        (IDProducto = @IDProducto)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="IDProducto" ColumnName="IDProducto" DataSourceName="Facturacion.dbo.Producto" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDProducto" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDProducto" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="FacturacionConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="newProducto" Modifier="Public" Name="newProducto" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="newProducto">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO [dbo].[Producto] ([Descripcion], [Precio], [Stock], [Notas], [IDIVA], [IDDepartamento]) VALUES (@Descripcion, @Precio, @Stock, @Notas, @IDIVA, @IDDepartamento)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Descripcion" ColumnName="Descripcion" DataSourceName="Facturacion.dbo.Producto" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Precio" ColumnName="Precio" DataSourceName="Facturacion.dbo.Producto" DataTypeServer="money" DbType="Currency" Direction="Input" ParameterName="@Precio" Precision="0" ProviderType="Money" Scale="0" Size="8" SourceColumn="Precio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Stock" ColumnName="Stock" DataSourceName="Facturacion.dbo.Producto" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Stock" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Stock" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Notas" ColumnName="Notas" DataSourceName="Facturacion.dbo.Producto" DataTypeServer="text" DbType="AnsiString" Direction="Input" ParameterName="@Notas" Precision="0" ProviderType="Text" Scale="0" Size="2147483647" SourceColumn="Notas" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDIVA" ColumnName="IDIVA" DataSourceName="Facturacion.dbo.Producto" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDIVA" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDIVA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDDepartamento" ColumnName="IDDepartamento" DataSourceName="Facturacion.dbo.Producto" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDDepartamento" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDDepartamento" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="IVATableAdapter" GeneratorDataComponentClassName="IVATableAdapter" Name="IVA" UserDataComponentName="IVATableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FacturacionConnectionString (Settings)" DbObjectName="Facturacion.dbo.IVA" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[IVA] WHERE (([IDIVA] = @Original_IDIVA) AND ([Descripcion] = @Original_Descripcion) AND ([Tarifa] = @Original_Tarifa))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDIVA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDIVA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Tarifa" Precision="8" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Tarifa" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[IVA] ([Descripcion], [Tarifa]) VALUES (@Descripcion, @Tarifa);
SELECT IDIVA, Descripcion, Tarifa FROM IVA WHERE (IDIVA = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Tarifa" Precision="8" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Tarifa" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDIVA, Descripcion, Tarifa FROM dbo.IVA</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[IVA] SET [Descripcion] = @Descripcion, [Tarifa] = @Tarifa WHERE (([IDIVA] = @Original_IDIVA) AND ([Descripcion] = @Original_Descripcion) AND ([Tarifa] = @Original_Tarifa));
SELECT IDIVA, Descripcion, Tarifa FROM IVA WHERE (IDIVA = @IDIVA)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Tarifa" Precision="8" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Tarifa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDIVA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDIVA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Tarifa" Precision="8" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Tarifa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDIVA" ColumnName="IDIVA" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDIVA" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDIVA" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDIVA" DataSetColumn="IDIVA" />
              <Mapping SourceColumn="Descripcion" DataSetColumn="Descripcion" />
              <Mapping SourceColumn="Tarifa" DataSetColumn="Tarifa" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="FacturacionConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="NewIva" Modifier="Public" Name="NewIva" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="NewIva">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO [dbo].[IVA] ([Descripcion], [Tarifa]) VALUES (@Descripcion, @Tarifa);</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Descripcion" ColumnName="Descripcion" DataSourceName="Facturacion.dbo.IVA" DataTypeServer="nvarchar(255)" DbType="String" Direction="Input" ParameterName="@Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="255" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Tarifa" ColumnName="Tarifa" DataSourceName="Facturacion.dbo.IVA" DataTypeServer="decimal(8, 2)" DbType="Decimal" Direction="Input" ParameterName="@Tarifa" Precision="8" ProviderType="Decimal" Scale="2" Size="5" SourceColumn="Tarifa" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FacturaTableAdapter" GeneratorDataComponentClassName="FacturaTableAdapter" Name="Factura" UserDataComponentName="FacturaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FacturacionConnectionString (Settings)" DbObjectName="Facturacion.dbo.Factura" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Factura] WHERE (([IDFactura] = @Original_IDFactura) AND ([IDCliente] = @Original_IDCliente) AND ([Fecha] = @Original_Fecha))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDFactura" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDFactura" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_IDCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IDCliente" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Fecha" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Fecha" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Factura] ([IDCliente], [Fecha]) VALUES (@IDCliente, @Fecha);
SELECT IDFactura, IDCliente, Fecha FROM Factura WHERE (IDFactura = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@IDCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IDCliente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Fecha" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Fecha" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDFactura, IDCliente, Fecha FROM dbo.Factura</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Factura] SET [IDCliente] = @IDCliente, [Fecha] = @Fecha WHERE (([IDFactura] = @Original_IDFactura) AND ([IDCliente] = @Original_IDCliente) AND ([Fecha] = @Original_Fecha));
SELECT IDFactura, IDCliente, Fecha FROM Factura WHERE (IDFactura = @IDFactura)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@IDCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IDCliente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Fecha" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Fecha" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDFactura" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDFactura" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_IDCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IDCliente" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Fecha" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Fecha" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDFactura" ColumnName="IDFactura" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDFactura" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDFactura" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDFactura" DataSetColumn="IDFactura" />
              <Mapping SourceColumn="IDCliente" DataSetColumn="IDCliente" />
              <Mapping SourceColumn="Fecha" DataSetColumn="Fecha" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="FacturacionConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="getIdUltimaFacturaIngresada" Modifier="Public" Name="getIdUltimaFacturaIngresada" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="getIdUltimaFacturaIngresada">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT MAX(IDFactura) AS IdFactura FROM Factura</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DetalleFacturaTmpTableAdapter" GeneratorDataComponentClassName="DetalleFacturaTmpTableAdapter" Name="DetalleFacturaTmp" UserDataComponentName="DetalleFacturaTmpTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FacturacionConnectionString (Settings)" DbObjectName="Facturacion.dbo.DetalleFacturaTmp" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[DetalleFacturaTmp] WHERE (([IDLinea] = @Original_IDLinea) AND ([IDProducto] = @Original_IDProducto) AND ([Descripcion] = @Original_Descripcion) AND ([Precio] = @Original_Precio) AND ([Cantidad] = @Original_Cantidad))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDLinea" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDLinea" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDProducto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDProducto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Precio" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Precio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Cantidad" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cantidad" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[DetalleFacturaTmp] ([IDProducto], [Descripcion], [Precio], [Cantidad]) VALUES (@IDProducto, @Descripcion, @Precio, @Cantidad);
SELECT IDLinea, IDProducto, Descripcion, Precio, Cantidad FROM DetalleFacturaTmp WHERE (IDLinea = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDProducto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDProducto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Precio" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Precio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Cantidad" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cantidad" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDLinea, IDProducto, Descripcion, Precio, Cantidad FROM dbo.DetalleFacturaTmp</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[DetalleFacturaTmp] SET [IDProducto] = @IDProducto, [Descripcion] = @Descripcion, [Precio] = @Precio, [Cantidad] = @Cantidad WHERE (([IDLinea] = @Original_IDLinea) AND ([IDProducto] = @Original_IDProducto) AND ([Descripcion] = @Original_Descripcion) AND ([Precio] = @Original_Precio) AND ([Cantidad] = @Original_Cantidad));
SELECT IDLinea, IDProducto, Descripcion, Precio, Cantidad FROM DetalleFacturaTmp WHERE (IDLinea = @IDLinea)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDProducto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDProducto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Precio" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Precio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Cantidad" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cantidad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDLinea" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDLinea" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDProducto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDProducto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Precio" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Precio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Cantidad" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cantidad" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDLinea" ColumnName="IDLinea" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDLinea" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDLinea" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDLinea" DataSetColumn="IDLinea" />
              <Mapping SourceColumn="IDProducto" DataSetColumn="IDProducto" />
              <Mapping SourceColumn="Descripcion" DataSetColumn="Descripcion" />
              <Mapping SourceColumn="Precio" DataSetColumn="Precio" />
              <Mapping SourceColumn="Cantidad" DataSetColumn="Cantidad" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="FacturacionConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="borrarTodo" Modifier="Public" Name="borrarTodo" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="borrarTodo">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM [dbo].[DetalleFacturaTmp]</CommandText>
                    <Parameters />
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="FacturacionConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="getCantidadTotalProductosEnChanguito" Modifier="Public" Name="getCantidadTotalProductosEnChanguito" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="getCantidadTotalProductosEnChanguito">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        SUM(Cantidad) AS Cantidad
FROM            DetalleFacturaTmp</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="FacturacionConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="getPrecioTotalAPagarPorElChanguito" Modifier="Public" Name="getPrecioTotalAPagarPorElChanguito" QueryType="Scalar" ScalarCallRetval="System.Decimal, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="getPrecioTotalAPagarPorElChanguito">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        SUM(Precio) AS Precio
FROM            DetalleFacturaTmp</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="FacturacionConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="newfacturaTemp" Modifier="Public" Name="newfacturaTemp" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="newfacturaTemp">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO [dbo].[DetalleFacturaTmp] ([IDProducto], [Descripcion], [Precio], [Cantidad]) VALUES (@IDProducto, @Descripcion, @Precio, @Cantidad)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="IDProducto" ColumnName="IDProducto" DataSourceName="Facturacion.dbo.DetalleFacturaTmp" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDProducto" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDProducto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Descripcion" ColumnName="Descripcion" DataSourceName="Facturacion.dbo.DetalleFacturaTmp" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Precio" ColumnName="Precio" DataSourceName="Facturacion.dbo.DetalleFacturaTmp" DataTypeServer="money" DbType="Currency" Direction="Input" ParameterName="@Precio" Precision="0" ProviderType="Money" Scale="0" Size="8" SourceColumn="Precio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Cantidad" ColumnName="Cantidad" DataSourceName="Facturacion.dbo.DetalleFacturaTmp" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Cantidad" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Cantidad" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DetalleFacturaTableAdapter" GeneratorDataComponentClassName="DetalleFacturaTableAdapter" Name="DetalleFactura" UserDataComponentName="DetalleFacturaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FacturacionConnectionString (Settings)" DbObjectName="Facturacion.dbo.DetalleFactura" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[DetalleFactura] WHERE (([IDFactura] = @Original_IDFactura) AND ([IDLinea] = @Original_IDLinea) AND ([IDProducto] = @Original_IDProducto) AND ([Descripcion] = @Original_Descripcion) AND ([Precio] = @Original_Precio) AND ([Cantidad] = @Original_Cantidad))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDFactura" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDFactura" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDLinea" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDLinea" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDProducto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDProducto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Precio" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Precio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Cantidad" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cantidad" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[DetalleFactura] ([IDFactura], [IDProducto], [Descripcion], [Precio], [Cantidad]) VALUES (@IDFactura, @IDProducto, @Descripcion, @Precio, @Cantidad);
SELECT IDFactura, IDLinea, IDProducto, Descripcion, Precio, Cantidad FROM DetalleFactura WHERE (IDFactura = @IDFactura) AND (IDLinea = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDFactura" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDFactura" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDProducto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDProducto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Precio" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Precio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Cantidad" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cantidad" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDFactura, IDLinea, IDProducto, Descripcion, Precio, Cantidad FROM dbo.DetalleFactura</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[DetalleFactura] SET [IDFactura] = @IDFactura, [IDProducto] = @IDProducto, [Descripcion] = @Descripcion, [Precio] = @Precio, [Cantidad] = @Cantidad WHERE (([IDFactura] = @Original_IDFactura) AND ([IDLinea] = @Original_IDLinea) AND ([IDProducto] = @Original_IDProducto) AND ([Descripcion] = @Original_Descripcion) AND ([Precio] = @Original_Precio) AND ([Cantidad] = @Original_Cantidad));
SELECT IDFactura, IDLinea, IDProducto, Descripcion, Precio, Cantidad FROM DetalleFactura WHERE (IDFactura = @IDFactura) AND (IDLinea = @IDLinea)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDFactura" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDFactura" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDProducto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDProducto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Precio" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Precio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Cantidad" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cantidad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDFactura" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDFactura" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDLinea" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDLinea" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDProducto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDProducto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Precio" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Precio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Cantidad" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cantidad" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDLinea" ColumnName="IDLinea" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDLinea" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDLinea" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDFactura" DataSetColumn="IDFactura" />
              <Mapping SourceColumn="IDLinea" DataSetColumn="IDLinea" />
              <Mapping SourceColumn="IDProducto" DataSetColumn="IDProducto" />
              <Mapping SourceColumn="Descripcion" DataSetColumn="Descripcion" />
              <Mapping SourceColumn="Precio" DataSetColumn="Precio" />
              <Mapping SourceColumn="Cantidad" DataSetColumn="Cantidad" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DepartamentoTableAdapter" GeneratorDataComponentClassName="DepartamentoTableAdapter" Name="Departamento" UserDataComponentName="DepartamentoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FacturacionConnectionString (Settings)" DbObjectName="Facturacion.dbo.Departamento" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Departamento] WHERE (([IDDepartamento] = @Original_IDDepartamento) AND ([Descripcion] = @Original_Descripcion))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDDepartamento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDDepartamento" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Departamento] ([Descripcion]) VALUES (@Descripcion);
SELECT IDDepartamento, Descripcion FROM Departamento WHERE (IDDepartamento = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDDepartamento, Descripcion FROM dbo.Departamento</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Departamento] SET [Descripcion] = @Descripcion WHERE (([IDDepartamento] = @Original_IDDepartamento) AND ([Descripcion] = @Original_Descripcion));
SELECT IDDepartamento, Descripcion FROM Departamento WHERE (IDDepartamento = @IDDepartamento)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDDepartamento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDDepartamento" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDDepartamento" ColumnName="IDDepartamento" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDDepartamento" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDDepartamento" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDDepartamento" DataSetColumn="IDDepartamento" />
              <Mapping SourceColumn="Descripcion" DataSetColumn="Descripcion" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="FacturacionConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="NewDepartamento" Modifier="Public" Name="NewDepartamento" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="NewDepartamento">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO [dbo].[Departamento] ([Descripcion]) VALUES (@Descripcion);</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Descripcion" ColumnName="Descripcion" DataSourceName="Facturacion.dbo.Departamento" DataTypeServer="nvarchar(255)" DbType="String" Direction="Input" ParameterName="@Descripcion" Precision="0" ProviderType="NVarChar" Scale="0" Size="255" SourceColumn="Descripcion" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ClienteTableAdapter" GeneratorDataComponentClassName="ClienteTableAdapter" Name="Cliente" UserDataComponentName="ClienteTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FacturacionConnectionString (Settings)" DbObjectName="Facturacion.dbo.Cliente" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Cliente] WHERE (([IDCliente] = @Original_IDCliente) AND ([Nombres] = @Original_Nombres) AND ([Apellidos] = @Original_Apellidos) AND ((@IsNull_Direccion = 1 AND [Direccion] IS NULL) OR ([Direccion] = @Original_Direccion)) AND ((@IsNull_Telefono = 1 AND [Telefono] IS NULL) OR ([Telefono] = @Original_Telefono)) AND ((@IsNull_Correo = 1 AND [Correo] IS NULL) OR ([Correo] = @Original_Correo)) AND ((@IsNull_FechaNacimiento = 1 AND [FechaNacimiento] IS NULL) OR ([FechaNacimiento] = @Original_FechaNacimiento)) AND ([Cupo] = @Original_Cupo))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_IDCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IDCliente" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Nombres" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nombres" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Apellidos" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Apellidos" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Direccion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Direccion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Direccion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Direccion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Telefono" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Telefono" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Telefono" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Telefono" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Correo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Correo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Correo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Correo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FechaNacimiento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FechaNacimiento" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_FechaNacimiento" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="FechaNacimiento" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Cupo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cupo" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Cliente] ([IDCliente], [Nombres], [Apellidos], [Direccion], [Telefono], [Correo], [FechaNacimiento], [Cupo]) VALUES (@IDCliente, @Nombres, @Apellidos, @Direccion, @Telefono, @Correo, @FechaNacimiento, @Cupo);
SELECT IDCliente, Nombres, Apellidos, Direccion, Telefono, Correo, FechaNacimiento, Cupo FROM Cliente WHERE (IDCliente = @IDCliente)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@IDCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IDCliente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Nombres" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nombres" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Apellidos" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Apellidos" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Direccion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Direccion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Telefono" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Telefono" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Correo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Correo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@FechaNacimiento" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="FechaNacimiento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Cupo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cupo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDCliente, Nombres, Apellidos, Direccion, Telefono, Correo, FechaNacimiento, Cupo FROM dbo.Cliente</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Cliente] SET [IDCliente] = @IDCliente, [Nombres] = @Nombres, [Apellidos] = @Apellidos, [Direccion] = @Direccion, [Telefono] = @Telefono, [Correo] = @Correo, [FechaNacimiento] = @FechaNacimiento, [Cupo] = @Cupo WHERE (([IDCliente] = @Original_IDCliente) AND ([Nombres] = @Original_Nombres) AND ([Apellidos] = @Original_Apellidos) AND ((@IsNull_Direccion = 1 AND [Direccion] IS NULL) OR ([Direccion] = @Original_Direccion)) AND ((@IsNull_Telefono = 1 AND [Telefono] IS NULL) OR ([Telefono] = @Original_Telefono)) AND ((@IsNull_Correo = 1 AND [Correo] IS NULL) OR ([Correo] = @Original_Correo)) AND ((@IsNull_FechaNacimiento = 1 AND [FechaNacimiento] IS NULL) OR ([FechaNacimiento] = @Original_FechaNacimiento)) AND ([Cupo] = @Original_Cupo));
SELECT IDCliente, Nombres, Apellidos, Direccion, Telefono, Correo, FechaNacimiento, Cupo FROM Cliente WHERE (IDCliente = @IDCliente)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@IDCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IDCliente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Nombres" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nombres" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Apellidos" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Apellidos" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Direccion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Direccion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Telefono" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Telefono" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Correo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Correo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@FechaNacimiento" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="FechaNacimiento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Cupo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cupo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_IDCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="IDCliente" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Nombres" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nombres" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Apellidos" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Apellidos" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Direccion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Direccion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Direccion" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Direccion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Telefono" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Telefono" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Telefono" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Telefono" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Correo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Correo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Correo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Correo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FechaNacimiento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FechaNacimiento" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_FechaNacimiento" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="FechaNacimiento" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Cupo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cupo" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDCliente" DataSetColumn="IDCliente" />
              <Mapping SourceColumn="Nombres" DataSetColumn="Nombres" />
              <Mapping SourceColumn="Apellidos" DataSetColumn="Apellidos" />
              <Mapping SourceColumn="Direccion" DataSetColumn="Direccion" />
              <Mapping SourceColumn="Telefono" DataSetColumn="Telefono" />
              <Mapping SourceColumn="Correo" DataSetColumn="Correo" />
              <Mapping SourceColumn="FechaNacimiento" DataSetColumn="FechaNacimiento" />
              <Mapping SourceColumn="Cupo" DataSetColumn="Cupo" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="FacturacionConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="existeCliente" Modifier="Public" Name="existeCliente" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="existeCliente">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT 1 FROM Cliente WHERE IDCliente = @IDCliente</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="IDCliente" ColumnName="IDCliente" DataSourceName="Facturacion.dbo.Cliente" DataTypeServer="nvarchar(20)" DbType="String" Direction="Input" ParameterName="@IDCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="20" SourceColumn="IDCliente" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="FacturacionConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="newCliente" Modifier="Public" Name="newCliente" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="newCliente">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO [dbo].[Cliente] ([IDCliente], [Nombres], [Apellidos], [Direccion], [Telefono], [Correo], [FechaNacimiento], [Cupo]) VALUES (@IDCliente, @Nombres, @Apellidos, @Direccion, @Telefono, @Correo, @FechaNacimiento, @Cupo)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="IDCliente" ColumnName="IDCliente" DataSourceName="Facturacion.dbo.Cliente" DataTypeServer="nvarchar(20)" DbType="String" Direction="Input" ParameterName="@IDCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="20" SourceColumn="IDCliente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Nombres" ColumnName="Nombres" DataSourceName="Facturacion.dbo.Cliente" DataTypeServer="nvarchar(30)" DbType="String" Direction="Input" ParameterName="@Nombres" Precision="0" ProviderType="NVarChar" Scale="0" Size="30" SourceColumn="Nombres" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Apellidos" ColumnName="Apellidos" DataSourceName="Facturacion.dbo.Cliente" DataTypeServer="nvarchar(30)" DbType="String" Direction="Input" ParameterName="@Apellidos" Precision="0" ProviderType="NVarChar" Scale="0" Size="30" SourceColumn="Apellidos" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Direccion" ColumnName="Direccion" DataSourceName="Facturacion.dbo.Cliente" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@Direccion" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="Direccion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Telefono" ColumnName="Telefono" DataSourceName="Facturacion.dbo.Cliente" DataTypeServer="nvarchar(20)" DbType="String" Direction="Input" ParameterName="@Telefono" Precision="0" ProviderType="NVarChar" Scale="0" Size="20" SourceColumn="Telefono" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Correo" ColumnName="Correo" DataSourceName="Facturacion.dbo.Cliente" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@Correo" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="Correo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="FechaNacimiento" ColumnName="FechaNacimiento" DataSourceName="Facturacion.dbo.Cliente" DataTypeServer="date" DbType="AnsiString" Direction="Input" ParameterName="@FechaNacimiento" Precision="0" ProviderType="Date" Scale="0" Size="3" SourceColumn="FechaNacimiento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Cupo" ColumnName="Cupo" DataSourceName="Facturacion.dbo.Cliente" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Cupo" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Cupo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DataSetFacturacion" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="DataSetFacturacion" msprop:Generator_UserDSName="DataSetFacturacion">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Producto" msprop:Generator_TableClassName="ProductoDataTable" msprop:Generator_TableVarName="tableProducto" msprop:Generator_RowChangedName="ProductoRowChanged" msprop:Generator_TablePropName="Producto" msprop:Generator_RowDeletingName="ProductoRowDeleting" msprop:Generator_RowChangingName="ProductoRowChanging" msprop:Generator_RowEvHandlerName="ProductoRowChangeEventHandler" msprop:Generator_RowDeletedName="ProductoRowDeleted" msprop:Generator_RowClassName="ProductoRow" msprop:Generator_UserTableName="Producto" msprop:Generator_RowEvArgName="ProductoRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDProducto" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIDProducto" msprop:Generator_ColumnPropNameInRow="IDProducto" msprop:Generator_ColumnPropNameInTable="IDProductoColumn" msprop:Generator_UserColumnName="IDProducto" type="xs:int" />
              <xs:element name="Descripcion" msprop:Generator_ColumnVarNameInTable="columnDescripcion" msprop:Generator_ColumnPropNameInRow="Descripcion" msprop:Generator_ColumnPropNameInTable="DescripcionColumn" msprop:Generator_UserColumnName="Descripcion">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Precio" msprop:Generator_ColumnVarNameInTable="columnPrecio" msprop:Generator_ColumnPropNameInRow="Precio" msprop:Generator_ColumnPropNameInTable="PrecioColumn" msprop:Generator_UserColumnName="Precio" type="xs:decimal" />
              <xs:element name="Stock" msprop:Generator_ColumnVarNameInTable="columnStock" msprop:Generator_ColumnPropNameInRow="Stock" msprop:Generator_ColumnPropNameInTable="StockColumn" msprop:Generator_UserColumnName="Stock" type="xs:int" />
              <xs:element name="Notas" msprop:Generator_ColumnVarNameInTable="columnNotas" msprop:Generator_ColumnPropNameInRow="Notas" msprop:Generator_ColumnPropNameInTable="NotasColumn" msprop:Generator_UserColumnName="Notas" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDIVA" msprop:Generator_ColumnVarNameInTable="columnIDIVA" msprop:Generator_ColumnPropNameInRow="IDIVA" msprop:Generator_ColumnPropNameInTable="IDIVAColumn" msprop:Generator_UserColumnName="IDIVA" type="xs:int" />
              <xs:element name="IDDepartamento" msprop:Generator_ColumnVarNameInTable="columnIDDepartamento" msprop:Generator_ColumnPropNameInRow="IDDepartamento" msprop:Generator_ColumnPropNameInTable="IDDepartamentoColumn" msprop:Generator_UserColumnName="IDDepartamento" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="IVA" msprop:Generator_TableClassName="IVADataTable" msprop:Generator_TableVarName="tableIVA" msprop:Generator_RowChangedName="IVARowChanged" msprop:Generator_TablePropName="IVA" msprop:Generator_RowDeletingName="IVARowDeleting" msprop:Generator_RowChangingName="IVARowChanging" msprop:Generator_RowEvHandlerName="IVARowChangeEventHandler" msprop:Generator_RowDeletedName="IVARowDeleted" msprop:Generator_RowClassName="IVARow" msprop:Generator_UserTableName="IVA" msprop:Generator_RowEvArgName="IVARowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDIVA" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIDIVA" msprop:Generator_ColumnPropNameInRow="IDIVA" msprop:Generator_ColumnPropNameInTable="IDIVAColumn" msprop:Generator_UserColumnName="IDIVA" type="xs:int" />
              <xs:element name="Descripcion" msprop:Generator_ColumnVarNameInTable="columnDescripcion" msprop:Generator_ColumnPropNameInRow="Descripcion" msprop:Generator_ColumnPropNameInTable="DescripcionColumn" msprop:Generator_UserColumnName="Descripcion">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Tarifa" msprop:Generator_ColumnVarNameInTable="columnTarifa" msprop:Generator_ColumnPropNameInRow="Tarifa" msprop:Generator_ColumnPropNameInTable="TarifaColumn" msprop:Generator_UserColumnName="Tarifa" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Factura" msprop:Generator_TableClassName="FacturaDataTable" msprop:Generator_TableVarName="tableFactura" msprop:Generator_RowChangedName="FacturaRowChanged" msprop:Generator_TablePropName="Factura" msprop:Generator_RowDeletingName="FacturaRowDeleting" msprop:Generator_RowChangingName="FacturaRowChanging" msprop:Generator_RowEvHandlerName="FacturaRowChangeEventHandler" msprop:Generator_RowDeletedName="FacturaRowDeleted" msprop:Generator_RowClassName="FacturaRow" msprop:Generator_UserTableName="Factura" msprop:Generator_RowEvArgName="FacturaRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDFactura" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIDFactura" msprop:Generator_ColumnPropNameInRow="IDFactura" msprop:Generator_ColumnPropNameInTable="IDFacturaColumn" msprop:Generator_UserColumnName="IDFactura" type="xs:int" />
              <xs:element name="IDCliente" msprop:Generator_ColumnVarNameInTable="columnIDCliente" msprop:Generator_ColumnPropNameInRow="IDCliente" msprop:Generator_ColumnPropNameInTable="IDClienteColumn" msprop:Generator_UserColumnName="IDCliente">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Fecha" msprop:Generator_ColumnVarNameInTable="columnFecha" msprop:Generator_ColumnPropNameInRow="Fecha" msprop:Generator_ColumnPropNameInTable="FechaColumn" msprop:Generator_UserColumnName="Fecha" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DetalleFacturaTmp" msprop:Generator_TableClassName="DetalleFacturaTmpDataTable" msprop:Generator_TableVarName="tableDetalleFacturaTmp" msprop:Generator_RowChangedName="DetalleFacturaTmpRowChanged" msprop:Generator_TablePropName="DetalleFacturaTmp" msprop:Generator_RowDeletingName="DetalleFacturaTmpRowDeleting" msprop:Generator_RowChangingName="DetalleFacturaTmpRowChanging" msprop:Generator_RowEvHandlerName="DetalleFacturaTmpRowChangeEventHandler" msprop:Generator_RowDeletedName="DetalleFacturaTmpRowDeleted" msprop:Generator_RowClassName="DetalleFacturaTmpRow" msprop:Generator_UserTableName="DetalleFacturaTmp" msprop:Generator_RowEvArgName="DetalleFacturaTmpRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDLinea" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIDLinea" msprop:Generator_ColumnPropNameInRow="IDLinea" msprop:Generator_ColumnPropNameInTable="IDLineaColumn" msprop:Generator_UserColumnName="IDLinea" type="xs:int" />
              <xs:element name="IDProducto" msprop:Generator_ColumnVarNameInTable="columnIDProducto" msprop:Generator_ColumnPropNameInRow="IDProducto" msprop:Generator_ColumnPropNameInTable="IDProductoColumn" msprop:Generator_UserColumnName="IDProducto" type="xs:int" />
              <xs:element name="Descripcion" msprop:Generator_ColumnVarNameInTable="columnDescripcion" msprop:Generator_ColumnPropNameInRow="Descripcion" msprop:Generator_ColumnPropNameInTable="DescripcionColumn" msprop:Generator_UserColumnName="Descripcion">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Precio" msprop:Generator_ColumnVarNameInTable="columnPrecio" msprop:Generator_ColumnPropNameInRow="Precio" msprop:Generator_ColumnPropNameInTable="PrecioColumn" msprop:Generator_UserColumnName="Precio" type="xs:decimal" />
              <xs:element name="Cantidad" msprop:Generator_ColumnVarNameInTable="columnCantidad" msprop:Generator_ColumnPropNameInRow="Cantidad" msprop:Generator_ColumnPropNameInTable="CantidadColumn" msprop:Generator_UserColumnName="Cantidad" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DetalleFactura" msprop:Generator_TableClassName="DetalleFacturaDataTable" msprop:Generator_TableVarName="tableDetalleFactura" msprop:Generator_RowChangedName="DetalleFacturaRowChanged" msprop:Generator_TablePropName="DetalleFactura" msprop:Generator_RowDeletingName="DetalleFacturaRowDeleting" msprop:Generator_RowChangingName="DetalleFacturaRowChanging" msprop:Generator_RowEvHandlerName="DetalleFacturaRowChangeEventHandler" msprop:Generator_RowDeletedName="DetalleFacturaRowDeleted" msprop:Generator_RowClassName="DetalleFacturaRow" msprop:Generator_UserTableName="DetalleFactura" msprop:Generator_RowEvArgName="DetalleFacturaRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDFactura" msprop:Generator_ColumnVarNameInTable="columnIDFactura" msprop:Generator_ColumnPropNameInRow="IDFactura" msprop:Generator_ColumnPropNameInTable="IDFacturaColumn" msprop:Generator_UserColumnName="IDFactura" type="xs:int" />
              <xs:element name="IDLinea" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIDLinea" msprop:Generator_ColumnPropNameInRow="IDLinea" msprop:Generator_ColumnPropNameInTable="IDLineaColumn" msprop:Generator_UserColumnName="IDLinea" type="xs:int" />
              <xs:element name="IDProducto" msprop:Generator_ColumnVarNameInTable="columnIDProducto" msprop:Generator_ColumnPropNameInRow="IDProducto" msprop:Generator_ColumnPropNameInTable="IDProductoColumn" msprop:Generator_UserColumnName="IDProducto" type="xs:int" />
              <xs:element name="Descripcion" msprop:Generator_ColumnVarNameInTable="columnDescripcion" msprop:Generator_ColumnPropNameInRow="Descripcion" msprop:Generator_ColumnPropNameInTable="DescripcionColumn" msprop:Generator_UserColumnName="Descripcion">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Precio" msprop:Generator_ColumnVarNameInTable="columnPrecio" msprop:Generator_ColumnPropNameInRow="Precio" msprop:Generator_ColumnPropNameInTable="PrecioColumn" msprop:Generator_UserColumnName="Precio" type="xs:decimal" />
              <xs:element name="Cantidad" msprop:Generator_ColumnVarNameInTable="columnCantidad" msprop:Generator_ColumnPropNameInRow="Cantidad" msprop:Generator_ColumnPropNameInTable="CantidadColumn" msprop:Generator_UserColumnName="Cantidad" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Departamento" msprop:Generator_TableClassName="DepartamentoDataTable" msprop:Generator_TableVarName="tableDepartamento" msprop:Generator_RowChangedName="DepartamentoRowChanged" msprop:Generator_TablePropName="Departamento" msprop:Generator_RowDeletingName="DepartamentoRowDeleting" msprop:Generator_RowChangingName="DepartamentoRowChanging" msprop:Generator_RowEvHandlerName="DepartamentoRowChangeEventHandler" msprop:Generator_RowDeletedName="DepartamentoRowDeleted" msprop:Generator_RowClassName="DepartamentoRow" msprop:Generator_UserTableName="Departamento" msprop:Generator_RowEvArgName="DepartamentoRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDDepartamento" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIDDepartamento" msprop:Generator_ColumnPropNameInRow="IDDepartamento" msprop:Generator_ColumnPropNameInTable="IDDepartamentoColumn" msprop:Generator_UserColumnName="IDDepartamento" type="xs:int" />
              <xs:element name="Descripcion" msprop:Generator_ColumnVarNameInTable="columnDescripcion" msprop:Generator_ColumnPropNameInRow="Descripcion" msprop:Generator_ColumnPropNameInTable="DescripcionColumn" msprop:Generator_UserColumnName="Descripcion">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Cliente" msprop:Generator_TableClassName="ClienteDataTable" msprop:Generator_TableVarName="tableCliente" msprop:Generator_RowChangedName="ClienteRowChanged" msprop:Generator_TablePropName="Cliente" msprop:Generator_RowDeletingName="ClienteRowDeleting" msprop:Generator_RowChangingName="ClienteRowChanging" msprop:Generator_RowEvHandlerName="ClienteRowChangeEventHandler" msprop:Generator_RowDeletedName="ClienteRowDeleted" msprop:Generator_RowClassName="ClienteRow" msprop:Generator_UserTableName="Cliente" msprop:Generator_RowEvArgName="ClienteRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDCliente" msprop:Generator_ColumnVarNameInTable="columnIDCliente" msprop:Generator_ColumnPropNameInRow="IDCliente" msprop:Generator_ColumnPropNameInTable="IDClienteColumn" msprop:Generator_UserColumnName="IDCliente">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Nombres" msprop:Generator_ColumnVarNameInTable="columnNombres" msprop:Generator_ColumnPropNameInRow="Nombres" msprop:Generator_ColumnPropNameInTable="NombresColumn" msprop:Generator_UserColumnName="Nombres">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Apellidos" msprop:Generator_ColumnVarNameInTable="columnApellidos" msprop:Generator_ColumnPropNameInRow="Apellidos" msprop:Generator_ColumnPropNameInTable="ApellidosColumn" msprop:Generator_UserColumnName="Apellidos">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Direccion" msprop:Generator_ColumnVarNameInTable="columnDireccion" msprop:Generator_ColumnPropNameInRow="Direccion" msprop:Generator_ColumnPropNameInTable="DireccionColumn" msprop:Generator_UserColumnName="Direccion" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Telefono" msprop:Generator_ColumnVarNameInTable="columnTelefono" msprop:Generator_ColumnPropNameInRow="Telefono" msprop:Generator_ColumnPropNameInTable="TelefonoColumn" msprop:Generator_UserColumnName="Telefono" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Correo" msprop:Generator_ColumnVarNameInTable="columnCorreo" msprop:Generator_ColumnPropNameInRow="Correo" msprop:Generator_ColumnPropNameInTable="CorreoColumn" msprop:Generator_UserColumnName="Correo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FechaNacimiento" msprop:Generator_ColumnVarNameInTable="columnFechaNacimiento" msprop:Generator_ColumnPropNameInRow="FechaNacimiento" msprop:Generator_ColumnPropNameInTable="FechaNacimientoColumn" msprop:Generator_UserColumnName="FechaNacimiento" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Cupo" msprop:Generator_ColumnVarNameInTable="columnCupo" msprop:Generator_ColumnPropNameInRow="Cupo" msprop:Generator_ColumnPropNameInTable="CupoColumn" msprop:Generator_UserColumnName="Cupo" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Producto" />
      <xs:field xpath="mstns:IDProducto" />
    </xs:unique>
    <xs:unique name="IVA_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:IVA" />
      <xs:field xpath="mstns:IDIVA" />
    </xs:unique>
    <xs:unique name="Factura_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Factura" />
      <xs:field xpath="mstns:IDFactura" />
    </xs:unique>
    <xs:unique name="DetalleFacturaTmp_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DetalleFacturaTmp" />
      <xs:field xpath="mstns:IDLinea" />
    </xs:unique>
    <xs:unique name="DetalleFactura_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DetalleFactura" />
      <xs:field xpath="mstns:IDFactura" />
      <xs:field xpath="mstns:IDLinea" />
    </xs:unique>
    <xs:unique name="Departamento_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Departamento" />
      <xs:field xpath="mstns:IDDepartamento" />
    </xs:unique>
    <xs:unique name="Cliente_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Cliente" />
      <xs:field xpath="mstns:IDCliente" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_Producto_Departamento" msdata:parent="Departamento" msdata:child="Producto" msdata:parentkey="IDDepartamento" msdata:childkey="IDDepartamento" msprop:Generator_UserChildTable="Producto" msprop:Generator_ChildPropName="GetProductoRows" msprop:Generator_UserRelationName="FK_Producto_Departamento" msprop:Generator_ParentPropName="DepartamentoRow" msprop:Generator_RelationVarName="relationFK_Producto_Departamento" msprop:Generator_UserParentTable="Departamento" />
      <msdata:Relationship name="FK_Producto_IVA" msdata:parent="IVA" msdata:child="Producto" msdata:parentkey="IDIVA" msdata:childkey="IDIVA" msprop:Generator_UserChildTable="Producto" msprop:Generator_ChildPropName="GetProductoRows" msprop:Generator_UserRelationName="FK_Producto_IVA" msprop:Generator_ParentPropName="IVARow" msprop:Generator_RelationVarName="relationFK_Producto_IVA" msprop:Generator_UserParentTable="IVA" />
      <msdata:Relationship name="FK_Factura_Cliente" msdata:parent="Cliente" msdata:child="Factura" msdata:parentkey="IDCliente" msdata:childkey="IDCliente" msprop:Generator_UserChildTable="Factura" msprop:Generator_ChildPropName="GetFacturaRows" msprop:Generator_UserRelationName="FK_Factura_Cliente" msprop:Generator_ParentPropName="ClienteRow" msprop:Generator_RelationVarName="relationFK_Factura_Cliente" msprop:Generator_UserParentTable="Cliente" />
      <msdata:Relationship name="FK_DetalleFacturaTmp_Producto" msdata:parent="Producto" msdata:child="DetalleFacturaTmp" msdata:parentkey="IDProducto" msdata:childkey="IDProducto" msprop:Generator_UserChildTable="DetalleFacturaTmp" msprop:Generator_ChildPropName="GetDetalleFacturaTmpRows" msprop:Generator_UserRelationName="FK_DetalleFacturaTmp_Producto" msprop:Generator_RelationVarName="relationFK_DetalleFacturaTmp_Producto" msprop:Generator_UserParentTable="Producto" msprop:Generator_ParentPropName="ProductoRow" />
      <msdata:Relationship name="FK_DetalleFactura_Factura" msdata:parent="Factura" msdata:child="DetalleFactura" msdata:parentkey="IDFactura" msdata:childkey="IDFactura" msprop:Generator_UserChildTable="DetalleFactura" msprop:Generator_ChildPropName="GetDetalleFacturaRows" msprop:Generator_UserRelationName="FK_DetalleFactura_Factura" msprop:Generator_RelationVarName="relationFK_DetalleFactura_Factura" msprop:Generator_UserParentTable="Factura" msprop:Generator_ParentPropName="FacturaRow" />
      <msdata:Relationship name="FK_DetalleFactura_Producto" msdata:parent="Producto" msdata:child="DetalleFactura" msdata:parentkey="IDProducto" msdata:childkey="IDProducto" msprop:Generator_UserChildTable="DetalleFactura" msprop:Generator_ChildPropName="GetDetalleFacturaRows" msprop:Generator_UserRelationName="FK_DetalleFactura_Producto" msprop:Generator_RelationVarName="relationFK_DetalleFactura_Producto" msprop:Generator_UserParentTable="Producto" msprop:Generator_ParentPropName="ProductoRow" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>